﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="LoadData.aspx.cs" Inherits="QualityRPT.LoadData" %>
<%@ Register TagPrefix="uc1" TagName="clheader" Src="include/cl_header.ascx" %>
<%@ Register TagPrefix="uc1" TagName="cltop" Src="include/cl_top.ascx" %>
<%@ Register TagPrefix="uc1" TagName="clleft" Src="include/cl_left.ascx" %>
<%@ Register TagPrefix="uc1" TagName="clfooter" Src="include/cl_footer.ascx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>ETC产品质量跟踪统计系统-数据导入</title>
    <uc1:clheader id="clheader" runat="server"/>
</head>
<body>
  <uc1:cltop id="cltop" runat="server"/>
  <div class="container-fluid">
    <div class="row-fluid">
        <uc1:clleft id="clleft" runat="server"/>
         <!-- this is content start-->
        <form id="Form1" runat="server">
         <div class="box span10">
			<div class="box-header well">
				<h2><i class="icon-th"></i>数据导入(请先将ixf数据上传到DB2数据库服务器)</h2>
			</div>
            <div class="box-content" style=" float:left">
                <asp:Label ID="Label1" runat="server" Text="起始时间："></asp:Label>
                <asp:TextBox ID="textBoxStart" runat="server" class="datetimepicker"></asp:TextBox>
                <asp:Label ID="Label2" runat="server" Text="结束时间："></asp:Label>
                <asp:TextBox ID="textBoxEnd" runat="server" class="datetimepicker"></asp:TextBox>
                <div style="clear:both;height:12px;"></div>
                <asp:Label ID="Label3" runat="server" Text="入口成功数据："></asp:Label>
                <span>ixf</span><asp:TextBox ID="textbox_entry_zh" runat="server"></asp:TextBox>
                <span>msg</span><asp:TextBox ID="textbox_entry_zh_msg" runat="server"></asp:TextBox>
                <div style="clear:both;height:12px;"></div>
                <asp:Label ID="Label4" runat="server" Text="入口失败数据："></asp:Label>
                <span>ixf</span><asp:TextBox ID="textbox_entry_special" runat="server"></asp:TextBox>
                <span>msg</span><asp:TextBox ID="textbox_entry_special_msg" runat="server"></asp:TextBox>
                <div style="clear:both;height:12px;"></div>
                <asp:Label ID="Label5" runat="server" Text="出口成功数据："></asp:Label>
                <span>ixf</span><asp:TextBox ID="textbox_exit_zh" runat="server"></asp:TextBox>
                <span>msg</span><asp:TextBox ID="textbox_exit_zh_msg" runat="server"></asp:TextBox>
                <div style="clear:both;height:12px;"></div>
                <asp:Label ID="Label6" runat="server" Text="出口失败数据："></asp:Label>
                <span>ixf</span><asp:TextBox ID="textbox_exit_special" runat="server"></asp:TextBox>
                <span>msg</span><asp:TextBox ID="textbox_exit_special_msg" runat="server"></asp:TextBox>
                <div style="clear:both;height:12px;"></div>
                <asp:Button ID="ButtonQ" runat="server" Text="导入" CssClass="botton" onclick="ButtonQ_Click" />
            </div>
         </div>
         </form>
         <div class="box span10">
					<div class="box-header well">
						<h2><i class="icon-th"></i>数据导入-<span id="span_t_consume" runat="server"></span></h2>
					</div>
					<div class="box-content">
						<ul class="nav nav-tabs" id="myTab">
							<li class="active"><a href="#exSpec">导入统计</a></li>
						</ul>
						<div id="myTabContent" class="tab-content">
							<div class="tab-pane active" id="exSpec">
								<div><h4>导入状态</h4></div>
                                <table class="table table-bordered bootstrap-datatable datatable">
						            <thead>
							          <tr>
                                          <th>表名</th>
                                          <th>读取行数</th>
                                          <th>忽略行数</th>
                                          <th>装入行数</th>
                                          <th>拒绝行数</th>
                                          <th>删除行数</th>
                                          <th>落实行数</th>
							          </tr>
						          </thead>   
						            <tbody>
                                        <asp:Repeater ID="repeater_load" runat="server">
                                            <ItemTemplate>
                                                <tr>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "tablename")%></td>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "readrows")%></td>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "skiprows")%></td>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "loadrows")%></td>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "rejectrows")%></td>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "deleterows")%></td>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "commitrows")%></td>                                            
                                                </tr>
                                            </ItemTemplate>
                                        </asp:Repeater>
                                    </tbody>
                                </table>
                                <div><h4>入口成功交易表汇总</h4></div>
                                <table class="table table-bordered bootstrap-datatable datatable">
						            <thead>
							          <tr>
                                          <th>日期</th>
                                          <th>数据行数</th>
							          </tr>
						          </thead>   
						            <tbody>
                                        <asp:Repeater ID="repeater_entry_zh" runat="server">
                                            <ItemTemplate>
                                                <tr>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "sum_date")%></td>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "trans_count")%></td>                             
                                                </tr>
                                            </ItemTemplate>
                                        </asp:Repeater>
                                    </tbody>
                                </table>
                                <div><h4>入口失败交易表汇总</h4></div>
                                <table class="table table-bordered bootstrap-datatable datatable">
						            <thead>
							          <tr>
                                          <th>日期</th>
                                          <th>数据行数</th>
							          </tr>
						          </thead>   
						            <tbody>
                                        <asp:Repeater ID="repeater_entry_special" runat="server">
                                            <ItemTemplate>
                                                <tr>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "sum_date")%></td>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "trans_count")%></td>                             
                                                </tr>
                                            </ItemTemplate>
                                        </asp:Repeater>
                                    </tbody>
                                </table>
                                <div><h4>出口成功交易表汇总</h4></div>
                                <table class="table table-bordered bootstrap-datatable datatable">
						            <thead>
							          <tr>
                                          <th>日期</th>
                                          <th>数据行数</th>
							          </tr>
						          </thead>   
						            <tbody>
                                        <asp:Repeater ID="repeater_exit_zh" runat="server">
                                            <ItemTemplate>
                                                <tr>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "sum_date")%></td>
                                                    <td><%#GetStatCount(DataBinder.Eval(Container.DataItem, "trans_count"))%></td>                             
                                                </tr>
                                            </ItemTemplate>
                                        </asp:Repeater>
                                    </tbody>
                                </table>
                                <div><h4>出口失败交易表汇总</h4></div>
                                <table class="table table-bordered bootstrap-datatable datatable">
						            <thead>
							          <tr>
                                          <th>日期</th>
                                          <th>数据行数</th>
							          </tr>
						          </thead>   
						            <tbody>
                                        <asp:Repeater ID="repeater_exit_special" runat="server">
                                            <ItemTemplate>
                                                <tr>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "sum_date")%></td>
                                                    <td><%# DataBinder.Eval(Container.DataItem, "trans_count")%></td>                             
                                                </tr>
                                            </ItemTemplate>
                                        </asp:Repeater>
                                    </tbody>
                                </table>
							</div>
                            <div class="tab-pane" id="exDetail">
							        
							</div>
					    </div>
					</div>
					</div>
          </div>		
         <!-- content end-->
    </div>
  <uc1:clfooter id="clfooter" runat="server"/>
</body>
</html>